@ECHO OFF
set /p SQLSERVER= Give the SQL Server instance name?
set /p DATABASENAME= Give the DATABASE name?
set /p USERNAME= Give the user name?
set /p PWD= Give the password?

REM CD .\TableCreationScripts
REM SQLCMD -S %SQLSERVER% -U %USERNAME% -P %PWD% -d %DATABASENAME% -i Ivy_CallAllTableCreationScripts.SQLCMD
REM CD ..\

CD .\TableCreationScripts
SQLCMD -S %SQLSERVER% -U %USERNAME% -P %PWD% -d %DATABASENAME% -i Ivy_CallTableAndKeyConstraintsRelationCreationScript.SQLCMD
CD ..\

CD .\StoredProcedureScripts
SQLCMD -S %SQLSERVER% -U %USERNAME% -P %PWD% -d %DATABASENAME% -i Ivy_CallAllStoredProcScripts.SQLCMD
CD ..\

CD .\DefaultDataCreationScripts
SQLCMD -S %SQLSERVER% -U %USERNAME% -P %PWD% -d %DATABASENAME% -i Ivy_CallAllDefaultDataCreationScripts.SQLCMD
CD ..\

PAUSE
@ECHO ON